Overview
Brought to you by YData
Dataset statistics
| Number of variables | 34 |
|---|---|
| Number of observations | 58913 |
| Missing cells | 172147 |
| Missing cells (%) | 8.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.3 MiB |
| Average record size in memory | 272.0 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 4 |
| Categorical | 12 |
| Text | 10 |
| Unsupported | 1 |
agency has constant value "DOHMH" | Constant |
agency_name has constant value "Department of Health and Mental Hygiene" | Constant |
complaint_type has constant value "Food Establishment" | Constant |
bbl is highly overall correlated with borough and 2 other fields | High correlation |
borough is highly overall correlated with bbl and 6 other fields | High correlation |
incident_zip is highly overall correlated with bbl and 4 other fields | High correlation |
latitude is highly overall correlated with borough and 2 other fields | High correlation |
longitude is highly overall correlated with borough and 3 other fields | High correlation |
park_borough is highly overall correlated with bbl and 6 other fields | High correlation |
resolution_description is highly overall correlated with status | High correlation |
status is highly overall correlated with resolution_description and 1 other fields | High correlation |
unique_key is highly overall correlated with status | High correlation |
x_coordinate_state_plane is highly overall correlated with borough and 3 other fields | High correlation |
y_coordinate_state_plane is highly overall correlated with borough and 2 other fields | High correlation |
location_type is highly imbalanced (84.5%) | Imbalance |
address_type is highly imbalanced (90.8%) | Imbalance |
status is highly imbalanced (67.2%) | Imbalance |
park_facility_name is highly imbalanced (99.9%) | Imbalance |
resolution_description is highly imbalanced (87.0%) | Imbalance |
incident_zip has 1566 (2.7%) missing values | Missing |
incident_address has 1594 (2.7%) missing values | Missing |
street_name has 1700 (2.9%) missing values | Missing |
cross_street_1 has 2381 (4.0%) missing values | Missing |
cross_street_2 has 2375 (4.0%) missing values | Missing |
intersection_street_1 has 4075 (6.9%) missing values | Missing |
intersection_street_2 has 4068 (6.9%) missing values | Missing |
address_type has 1949 (3.3%) missing values | Missing |
city has 2100 (3.6%) missing values | Missing |
landmark has 7431 (12.6%) missing values | Missing |
bbl has 4054 (6.9%) missing values | Missing |
x_coordinate_state_plane has 1566 (2.7%) missing values | Missing |
y_coordinate_state_plane has 1564 (2.7%) missing values | Missing |
latitude has 1569 (2.7%) missing values | Missing |
longitude has 1569 (2.7%) missing values | Missing |
location has 1569 (2.7%) missing values | Missing |
closed_date has 6875 (11.7%) missing values | Missing |
resolution_description has 5769 (9.8%) missing values | Missing |
resolution_action_updated_date has 5769 (9.8%) missing values | Missing |
due_date has 53677 (91.1%) missing values | Missing |
facility_type has 58913 (100.0%) missing values | Missing |
unique_key has unique values | Unique |
facility_type is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-11-19 05:02:10.371907 |
|---|---|
| Analysis finished | 2024-11-19 05:45:56.688048 |
| Duration | 43 minutes and 46.32 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
unique_key
Real number (ℝ)
High correlation  Unique 
| Distinct | 58913 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52693783 |
| Minimum | 41307236 |
|---|---|
| Maximum | 62607416 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | 41307236 |
|---|---|
| 5-th percentile | 42235314 |
| Q1 | 46443669 |
| median | 53699381 |
| Q3 | 58293912 |
| 95-th percentile | 61841452 |
| Maximum | 62607416 |
| Range | 21300180 |
| Interquartile range (IQR) | 11850243 |
Descriptive statistics
| Standard deviation | 6438895.9 |
|---|---|
| Coefficient of variation (CV) | 0.1221946 |
| Kurtosis | -1.2598773 |
| Mean | 52693783 |
| Median Absolute Deviation (MAD) | 5638417 |
| Skewness | -0.20788897 |
| Sum | 3.1043488 × 1012 |
| Variance | 4.145938 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 41307236 | 1 | < 0.1% |
| 41318285 | 1 | < 0.1% |
| 41316446 | 1 | < 0.1% |
| 41316887 | 1 | < 0.1% |
| 41318573 | 1 | < 0.1% |
| 41317956 | 1 | < 0.1% |
| 41315009 | 1 | < 0.1% |
| 41318163 | 1 | < 0.1% |
| 41319075 | 1 | < 0.1% |
| 41317825 | 1 | < 0.1% |
| Other values (58903) | 58903 |
| Value | Count | Frequency (%) |
| 41307236 | 1 | |
| 41314791 | 1 | |
| 41314982 | 1 | |
| 41315009 | 1 | |
| 41315010 | 1 | |
| 41315466 | 1 | |
| 41316420 | 1 | |
| 41316445 | 1 | |
| 41316446 | 1 | |
| 41316449 | 1 |
| Value | Count | Frequency (%) |
| 62607416 | 1 | |
| 62607315 | 1 | |
| 62606493 | 1 | |
| 62606492 | 1 | |
| 62606141 | 1 | |
| 62605637 | 1 | |
| 62605571 | 1 | |
| 62605500 | 1 | |
| 62604774 | 1 | |
| 62604570 | 1 |
created_date
Date
| Distinct | 58896 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| Minimum | 2019-01-01 01:17:04 |
|---|---|
| Maximum | 2024-09-29 23:42:42 |
agency
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| DOHMH |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DOHMH |
|---|---|
| 2nd row | DOHMH |
| 3rd row | DOHMH |
| 4th row | DOHMH |
| 5th row | DOHMH |
Common Values
| Value | Count | Frequency (%) |
| DOHMH | 58913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| dohmh | 58913 |
Most occurring characters
| Value | Count | Frequency (%) |
| H | 117826 | |
| D | 58913 | |
| O | 58913 | |
| M | 58913 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 294565 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| H | 117826 | |
| D | 58913 | |
| O | 58913 | |
| M | 58913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 294565 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| H | 117826 | |
| D | 58913 | |
| O | 58913 | |
| M | 58913 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 294565 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| H | 117826 | |
| D | 58913 | |
| O | 58913 | |
| M | 58913 |
agency_name
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| Department of Health and Mental Hygiene |
|---|
Length
| Max length | 39 |
|---|---|
| Median length | 39 |
| Mean length | 39 |
| Min length | 39 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Department of Health and Mental Hygiene |
|---|---|
| 2nd row | Department of Health and Mental Hygiene |
| 3rd row | Department of Health and Mental Hygiene |
| 4th row | Department of Health and Mental Hygiene |
| 5th row | Department of Health and Mental Hygiene |
Common Values
| Value | Count | Frequency (%) |
| Department of Health and Mental Hygiene | 58913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| department | 58913 | |
| of | 58913 | |
| health | 58913 | |
| and | 58913 | |
| mental | 58913 | |
| hygiene | 58913 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 353478 | |
| 294565 | ||
| a | 235652 | |
| n | 235652 | |
| t | 235652 | |
| l | 117826 | 5.1% |
| H | 117826 | 5.1% |
| p | 58913 | 2.6% |
| D | 58913 | 2.6% |
| m | 58913 | 2.6% |
| Other values (9) | 530217 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2297607 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 353478 | |
| 294565 | ||
| a | 235652 | |
| n | 235652 | |
| t | 235652 | |
| l | 117826 | 5.1% |
| H | 117826 | 5.1% |
| p | 58913 | 2.6% |
| D | 58913 | 2.6% |
| m | 58913 | 2.6% |
| Other values (9) | 530217 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2297607 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 353478 | |
| 294565 | ||
| a | 235652 | |
| n | 235652 | |
| t | 235652 | |
| l | 117826 | 5.1% |
| H | 117826 | 5.1% |
| p | 58913 | 2.6% |
| D | 58913 | 2.6% |
| m | 58913 | 2.6% |
| Other values (9) | 530217 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2297607 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 353478 | |
| 294565 | ||
| a | 235652 | |
| n | 235652 | |
| t | 235652 | |
| l | 117826 | 5.1% |
| H | 117826 | 5.1% |
| p | 58913 | 2.6% |
| D | 58913 | 2.6% |
| m | 58913 | 2.6% |
| Other values (9) | 530217 |
complaint_type
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| Food Establishment |
|---|
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Food Establishment |
|---|---|
| 2nd row | Food Establishment |
| 3rd row | Food Establishment |
| 4th row | Food Establishment |
| 5th row | Food Establishment |
Common Values
| Value | Count | Frequency (%) |
| Food Establishment | 58913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| food | 58913 | |
| establishment | 58913 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 117826 | 11.1% |
| s | 117826 | 11.1% |
| t | 117826 | 11.1% |
| d | 58913 | 5.6% |
| F | 58913 | 5.6% |
| E | 58913 | 5.6% |
| 58913 | 5.6% | |
| a | 58913 | 5.6% |
| b | 58913 | 5.6% |
| l | 58913 | 5.6% |
| Other values (5) | 294565 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1060434 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 117826 | 11.1% |
| s | 117826 | 11.1% |
| t | 117826 | 11.1% |
| d | 58913 | 5.6% |
| F | 58913 | 5.6% |
| E | 58913 | 5.6% |
| 58913 | 5.6% | |
| a | 58913 | 5.6% |
| b | 58913 | 5.6% |
| l | 58913 | 5.6% |
| Other values (5) | 294565 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1060434 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 117826 | 11.1% |
| s | 117826 | 11.1% |
| t | 117826 | 11.1% |
| d | 58913 | 5.6% |
| F | 58913 | 5.6% |
| E | 58913 | 5.6% |
| 58913 | 5.6% | |
| a | 58913 | 5.6% |
| b | 58913 | 5.6% |
| l | 58913 | 5.6% |
| Other values (5) | 294565 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1060434 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 117826 | 11.1% |
| s | 117826 | 11.1% |
| t | 117826 | 11.1% |
| d | 58913 | 5.6% |
| F | 58913 | 5.6% |
| E | 58913 | 5.6% |
| 58913 | 5.6% | |
| a | 58913 | 5.6% |
| b | 58913 | 5.6% |
| l | 58913 | 5.6% |
| Other values (5) | 294565 |
descriptor
Categorical
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| Rodents/Insects/Garbage | |
|---|---|
| Food Spoiled | |
| Bare Hands in Contact w/ Food | |
| Food Contaminated | |
| Letter Grading | |
| Other values (27) |
Length
| Max length | 29 |
|---|---|
| Median length | 25 |
| Mean length | 19.491521 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bare Hands in Contact w/ Food |
|---|---|
| 2nd row | Rodents/Insects/Garbage |
| 3rd row | Rodents/Insects/Garbage |
| 4th row | Rodents/Insects/Garbage |
| 5th row | Bare Hands in Contact w/ Food |
Common Values
| Value | Count | Frequency (%) |
| Rodents/Insects/Garbage | 19324 | |
| Food Spoiled | 4723 | 8.0% |
| Bare Hands in Contact w/ Food | 4699 | 8.0% |
| Food Contaminated | 3976 | 6.7% |
| Letter Grading | 3504 | 5.9% |
| No Permit or License | 2843 | 4.8% |
| Pet/Animal | 2683 | 4.6% |
| Food Worker Hygiene | 2434 | 4.1% |
| Food Contains Foreign Object | 2278 | 3.9% |
| Kitchen/Food Prep Area | 1963 | 3.3% |
| Other values (22) | 10486 |
Length
| Value | Count | Frequency (%) |
| food | 22225 | |
| rodents/insects/garbage | 19324 | 15.2% |
| spoiled | 4723 | 3.7% |
| bare | 4699 | 3.7% |
| hands | 4699 | 3.7% |
| in | 4699 | 3.7% |
| contact | 4699 | 3.7% |
| w | 4699 | 3.7% |
| contaminated | 3976 | 3.1% |
| letter | 3504 | 2.8% |
| Other values (43) | 49535 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 120934 | 10.5% |
| o | 104044 | 9.1% |
| t | 89063 | 7.8% |
| n | 88461 | 7.7% |
| a | 80050 | 7.0% |
| s | 71805 | 6.3% |
| 67869 | 5.9% | |
| d | 62604 | 5.5% |
| r | 58592 | 5.1% |
| / | 49676 | 4.3% |
| Other values (37) | 355206 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1148304 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 120934 | 10.5% |
| o | 104044 | 9.1% |
| t | 89063 | 7.8% |
| n | 88461 | 7.7% |
| a | 80050 | 7.0% |
| s | 71805 | 6.3% |
| 67869 | 5.9% | |
| d | 62604 | 5.5% |
| r | 58592 | 5.1% |
| / | 49676 | 4.3% |
| Other values (37) | 355206 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1148304 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 120934 | 10.5% |
| o | 104044 | 9.1% |
| t | 89063 | 7.8% |
| n | 88461 | 7.7% |
| a | 80050 | 7.0% |
| s | 71805 | 6.3% |
| 67869 | 5.9% | |
| d | 62604 | 5.5% |
| r | 58592 | 5.1% |
| / | 49676 | 4.3% |
| Other values (37) | 355206 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1148304 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 120934 | 10.5% |
| o | 104044 | 9.1% |
| t | 89063 | 7.8% |
| n | 88461 | 7.7% |
| a | 80050 | 7.0% |
| s | 71805 | 6.3% |
| 67869 | 5.9% | |
| d | 62604 | 5.5% |
| r | 58592 | 5.1% |
| / | 49676 | 4.3% |
| Other values (37) | 355206 |
location_type
Categorical
Imbalance 
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Memory size | 460.4 KiB |
| Restaurant/Bar/Deli/Bakery | |
|---|---|
| Other (Explain Below) | 3654 |
| 1-2 Family Dwelling | 759 |
| Restaurant | 713 |
| Catering Service | 266 |
| Other values (35) | 1419 |
Length
| Max length | 36 |
|---|---|
| Median length | 26 |
| Mean length | 25.182074 |
| Min length | 5 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Restaurant/Bar/Deli/Bakery |
|---|---|
| 2nd row | Restaurant/Bar/Deli/Bakery |
| 3rd row | Restaurant/Bar/Deli/Bakery |
| 4th row | Restaurant/Bar/Deli/Bakery |
| 5th row | Restaurant/Bar/Deli/Bakery |
Common Values
| Value | Count | Frequency (%) |
| Restaurant/Bar/Deli/Bakery | 52088 | |
| Other (Explain Below) | 3654 | 6.2% |
| 1-2 Family Dwelling | 759 | 1.3% |
| Restaurant | 713 | 1.2% |
| Catering Service | 266 | 0.5% |
| Other (explain in Complaint Details) | 210 | 0.4% |
| Commercial Building | 153 | 0.3% |
| Store | 145 | 0.2% |
| Residence | 142 | 0.2% |
| Cafeteria - College/University | 101 | 0.2% |
| Other values (30) | 668 | 1.1% |
Length
| Value | Count | Frequency (%) |
| restaurant/bar/deli/bakery | 52088 | |
| other | 3954 | 5.6% |
| explain | 3864 | 5.5% |
| below | 3654 | 5.2% |
| family | 832 | 1.2% |
| 1-2 | 808 | 1.2% |
| dwelling | 759 | 1.1% |
| restaurant | 713 | 1.0% |
| catering | 278 | 0.4% |
| service | 266 | 0.4% |
| Other values (48) | 3034 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 216044 | |
| e | 169034 | |
| r | 162803 | |
| / | 156366 | |
| t | 111321 | 7.5% |
| B | 108076 | 7.3% |
| l | 63155 | 4.3% |
| i | 60359 | 4.1% |
| n | 59058 | 4.0% |
| s | 53339 | 3.6% |
| Other values (40) | 323644 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1483199 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 216044 | |
| e | 169034 | |
| r | 162803 | |
| / | 156366 | |
| t | 111321 | 7.5% |
| B | 108076 | 7.3% |
| l | 63155 | 4.3% |
| i | 60359 | 4.1% |
| n | 59058 | 4.0% |
| s | 53339 | 3.6% |
| Other values (40) | 323644 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1483199 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 216044 | |
| e | 169034 | |
| r | 162803 | |
| / | 156366 | |
| t | 111321 | 7.5% |
| B | 108076 | 7.3% |
| l | 63155 | 4.3% |
| i | 60359 | 4.1% |
| n | 59058 | 4.0% |
| s | 53339 | 3.6% |
| Other values (40) | 323644 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1483199 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 216044 | |
| e | 169034 | |
| r | 162803 | |
| / | 156366 | |
| t | 111321 | 7.5% |
| B | 108076 | 7.3% |
| l | 63155 | 4.3% |
| i | 60359 | 4.1% |
| n | 59058 | 4.0% |
| s | 53339 | 3.6% |
| Other values (40) | 323644 |
incident_zip
Real number (ℝ)
High correlation  Missing 
| Distinct | 211 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1566 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10725.561 |
| Minimum | 10000 |
|---|---|
| Maximum | 12345 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 10004 |
| Q1 | 10028 |
| median | 11103 |
| Q3 | 11232 |
| 95-th percentile | 11419 |
| Maximum | 12345 |
| Range | 2345 |
| Interquartile range (IQR) | 1204 |
Descriptive statistics
| Standard deviation | 587.41274 |
|---|---|
| Coefficient of variation (CV) | 0.054767555 |
| Kurtosis | -1.78548 |
| Mean | 10725.561 |
| Median Absolute Deviation (MAD) | 331 |
| Skewness | -0.13598334 |
| Sum | 6.1507873 × 108 |
| Variance | 345053.73 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10003 | 1175 | 2.0% |
| 11355 | 1102 | 1.9% |
| 11201 | 1048 | 1.8% |
| 10019 | 1021 | 1.7% |
| 10002 | 940 | 1.6% |
| 10014 | 871 | 1.5% |
| 10013 | 833 | 1.4% |
| 10036 | 817 | 1.4% |
| 11209 | 800 | 1.4% |
| 10011 | 792 | 1.3% |
| Other values (201) | 47948 | |
| (Missing) | 1566 | 2.7% |
| Value | Count | Frequency (%) |
| 10000 | 6 | < 0.1% |
| 10001 | 738 | |
| 10002 | 940 | |
| 10003 | 1175 | |
| 10004 | 131 | 0.2% |
| 10005 | 84 | 0.1% |
| 10006 | 48 | 0.1% |
| 10007 | 258 | 0.4% |
| 10009 | 679 | |
| 10010 | 430 | 0.7% |
| Value | Count | Frequency (%) |
| 12345 | 1 | < 0.1% |
| 11697 | 6 | < 0.1% |
| 11695 | 3 | < 0.1% |
| 11694 | 104 | |
| 11693 | 84 | 0.1% |
| 11692 | 34 | 0.1% |
| 11691 | 123 | |
| 11436 | 74 | 0.1% |
| 11435 | 252 | |
| 11434 | 257 |
incident_address
Text
Missing 
| Distinct | 25182 |
|---|---|
| Distinct (%) | 43.9% |
| Missing | 1594 |
| Missing (%) | 2.7% |
| Memory size | 460.4 KiB |
Length
| Max length | 38 |
|---|---|
| Median length | 33 |
| Mean length | 18.08095 |
| Min length | 1 |
Unique
| Unique | 14513 ? |
|---|---|
| Unique (%) | 25.3% |
Sample
| 1st row | 523 BRIGHTON BEACH AVENUE |
|---|---|
| 2nd row | 2117 WILLIAMBRIDGE ROAD |
| 3rd row | 31 WEST 32 STREET |
| 4th row | 114 |
| 5th row | 2605 CONEY ISLAND AVENUE |
| Value | Count | Frequency (%) |
| avenue | 26908 | 14.8% |
| street | 17513 | 9.7% |
| boulevard | 5281 | 2.9% |
| east | 4002 | 2.2% |
| west | 3669 | 2.0% |
| broadway | 2497 | 1.4% |
| road | 1907 | 1.1% |
| 3 | 1295 | 0.7% |
| 5 | 998 | 0.6% |
| 1 | 976 | 0.5% |
| Other values (9424) | 116197 |
Most occurring characters
| Value | Count | Frequency (%) |
| 134720 | 13.0% | |
| E | 127894 | 12.3% |
| A | 68491 | 6.6% |
| T | 62822 | 6.1% |
| N | 51377 | 5.0% |
| R | 50832 | 4.9% |
| 1 | 44804 | 4.3% |
| S | 42663 | 4.1% |
| U | 40865 | 3.9% |
| V | 34982 | 3.4% |
| Other values (30) | 376932 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1036382 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 134720 | 13.0% | |
| E | 127894 | 12.3% |
| A | 68491 | 6.6% |
| T | 62822 | 6.1% |
| N | 51377 | 5.0% |
| R | 50832 | 4.9% |
| 1 | 44804 | 4.3% |
| S | 42663 | 4.1% |
| U | 40865 | 3.9% |
| V | 34982 | 3.4% |
| Other values (30) | 376932 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1036382 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 134720 | 13.0% | |
| E | 127894 | 12.3% |
| A | 68491 | 6.6% |
| T | 62822 | 6.1% |
| N | 51377 | 5.0% |
| R | 50832 | 4.9% |
| 1 | 44804 | 4.3% |
| S | 42663 | 4.1% |
| U | 40865 | 3.9% |
| V | 34982 | 3.4% |
| Other values (30) | 376932 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1036382 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 134720 | 13.0% | |
| E | 127894 | 12.3% |
| A | 68491 | 6.6% |
| T | 62822 | 6.1% |
| N | 51377 | 5.0% |
| R | 50832 | 4.9% |
| 1 | 44804 | 4.3% |
| S | 42663 | 4.1% |
| U | 40865 | 3.9% |
| V | 34982 | 3.4% |
| Other values (30) | 376932 |
street_name
Text
Missing 
| Distinct | 2574 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 1700 |
| Missing (%) | 2.9% |
| Memory size | 460.4 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.479506 |
| Min length | 3 |
Unique
| Unique | 728 ? |
|---|---|
| Unique (%) | 1.3% |
Sample
| 1st row | BRIGHTON BEACH AVENUE |
|---|---|
| 2nd row | WILLIAMBRIDGE ROAD |
| 3rd row | WEST 32 STREET |
| 4th row | CONEY ISLAND AVENUE |
| 5th row | PROSPECT PARK WEST |
| Value | Count | Frequency (%) |
| avenue | 26908 | |
| street | 17513 | 14.0% |
| boulevard | 5281 | 4.2% |
| east | 3997 | 3.2% |
| west | 3661 | 2.9% |
| broadway | 2497 | 2.0% |
| road | 1907 | 1.5% |
| 3 | 1261 | 1.0% |
| 5 | 898 | 0.7% |
| 8 | 884 | 0.7% |
| Other values (1524) | 59885 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 127862 | |
| 78275 | ||
| A | 68213 | 8.8% |
| T | 62807 | 8.1% |
| N | 51373 | 6.7% |
| R | 50830 | 6.6% |
| S | 42637 | 5.5% |
| U | 40865 | 5.3% |
| V | 34982 | 4.5% |
| O | 29965 | 3.9% |
| Other values (29) | 183394 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 771203 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 127862 | |
| 78275 | ||
| A | 68213 | 8.8% |
| T | 62807 | 8.1% |
| N | 51373 | 6.7% |
| R | 50830 | 6.6% |
| S | 42637 | 5.5% |
| U | 40865 | 5.3% |
| V | 34982 | 4.5% |
| O | 29965 | 3.9% |
| Other values (29) | 183394 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 771203 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 127862 | |
| 78275 | ||
| A | 68213 | 8.8% |
| T | 62807 | 8.1% |
| N | 51373 | 6.7% |
| R | 50830 | 6.6% |
| S | 42637 | 5.5% |
| U | 40865 | 5.3% |
| V | 34982 | 4.5% |
| O | 29965 | 3.9% |
| Other values (29) | 183394 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 771203 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 127862 | |
| 78275 | ||
| A | 68213 | 8.8% |
| T | 62807 | 8.1% |
| N | 51373 | 6.7% |
| R | 50830 | 6.6% |
| S | 42637 | 5.5% |
| U | 40865 | 5.3% |
| V | 34982 | 4.5% |
| O | 29965 | 3.9% |
| Other values (29) | 183394 |
cross_street_1
Text
Missing 
| Distinct | 4021 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 2381 |
| Missing (%) | 4.0% |
| Memory size | 460.4 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.350403 |
| Min length | 4 |
Unique
| Unique | 887 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | BRIGHTON 5 STREET |
|---|---|
| 2nd row | LYDIG AVENUE |
| 3rd row | 5 AVENUE |
| 4th row | BERRY STRE |
| 5th row | AVENUE W |
| Value | Count | Frequency (%) |
| street | 28877 | |
| avenue | 18298 | 13.9% |
| east | 6567 | 5.0% |
| west | 5623 | 4.3% |
| place | 2009 | 1.5% |
| road | 1591 | 1.2% |
| boulevard | 1242 | 0.9% |
| 5 | 1158 | 0.9% |
| barclay | 711 | 0.5% |
| broadway | 700 | 0.5% |
| Other values (2541) | 65057 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 134512 | |
| 96128 | ||
| T | 83274 | |
| A | 53813 | 7.1% |
| R | 53664 | 7.1% |
| S | 53312 | 7.1% |
| N | 37705 | 5.0% |
| U | 24960 | 3.3% |
| V | 21926 | 2.9% |
| O | 20077 | 2.7% |
| Other values (33) | 175354 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 754725 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 134512 | |
| 96128 | ||
| T | 83274 | |
| A | 53813 | 7.1% |
| R | 53664 | 7.1% |
| S | 53312 | 7.1% |
| N | 37705 | 5.0% |
| U | 24960 | 3.3% |
| V | 21926 | 2.9% |
| O | 20077 | 2.7% |
| Other values (33) | 175354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 754725 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 134512 | |
| 96128 | ||
| T | 83274 | |
| A | 53813 | 7.1% |
| R | 53664 | 7.1% |
| S | 53312 | 7.1% |
| N | 37705 | 5.0% |
| U | 24960 | 3.3% |
| V | 21926 | 2.9% |
| O | 20077 | 2.7% |
| Other values (33) | 175354 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 754725 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 134512 | |
| 96128 | ||
| T | 83274 | |
| A | 53813 | 7.1% |
| R | 53664 | 7.1% |
| S | 53312 | 7.1% |
| N | 37705 | 5.0% |
| U | 24960 | 3.3% |
| V | 21926 | 2.9% |
| O | 20077 | 2.7% |
| Other values (33) | 175354 |
cross_street_2
Text
Missing 
| Distinct | 4049 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 2375 |
| Missing (%) | 4.0% |
| Memory size | 460.4 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.42559 |
| Min length | 4 |
Unique
| Unique | 910 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | BRIGHTON 6 STREET |
|---|---|
| 2nd row | PELHAM PARKWAY SOUTH |
| 3rd row | BROADWAY |
| 4th row | MIKE LEE |
| 5th row | LANCASTER AVENUE |
| Value | Count | Frequency (%) |
| street | 28887 | |
| avenue | 17975 | 13.6% |
| east | 6567 | 5.0% |
| west | 5907 | 4.5% |
| place | 2072 | 1.6% |
| road | 1896 | 1.4% |
| boulevard | 1177 | 0.9% |
| broadway | 746 | 0.6% |
| sanford | 736 | 0.6% |
| 3 | 681 | 0.5% |
| Other values (2525) | 65600 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 133901 | |
| 96979 | ||
| T | 84232 | |
| S | 54579 | 7.2% |
| R | 53668 | 7.1% |
| A | 52734 | 6.9% |
| N | 39705 | 5.2% |
| U | 24730 | 3.3% |
| O | 22668 | 3.0% |
| V | 21776 | 2.9% |
| Other values (33) | 174084 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 759056 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 133901 | |
| 96979 | ||
| T | 84232 | |
| S | 54579 | 7.2% |
| R | 53668 | 7.1% |
| A | 52734 | 6.9% |
| N | 39705 | 5.2% |
| U | 24730 | 3.3% |
| O | 22668 | 3.0% |
| V | 21776 | 2.9% |
| Other values (33) | 174084 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 759056 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 133901 | |
| 96979 | ||
| T | 84232 | |
| S | 54579 | 7.2% |
| R | 53668 | 7.1% |
| A | 52734 | 6.9% |
| N | 39705 | 5.2% |
| U | 24730 | 3.3% |
| O | 22668 | 3.0% |
| V | 21776 | 2.9% |
| Other values (33) | 174084 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 759056 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 133901 | |
| 96979 | ||
| T | 84232 | |
| S | 54579 | 7.2% |
| R | 53668 | 7.1% |
| A | 52734 | 6.9% |
| N | 39705 | 5.2% |
| U | 24730 | 3.3% |
| O | 22668 | 3.0% |
| V | 21776 | 2.9% |
| Other values (33) | 174084 |
Missing 
| Distinct | 3929 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 4075 |
| Missing (%) | 6.9% |
| Memory size | 460.4 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.372625 |
| Min length | 4 |
Unique
| Unique | 894 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | BRIGHTON 5 STREET |
|---|---|
| 2nd row | LYDIG AVENUE |
| 3rd row | 5 AVENUE |
| 4th row | BERRY STRE |
| 5th row | AVENUE W |
| Value | Count | Frequency (%) |
| street | 27986 | |
| avenue | 17785 | 13.9% |
| east | 6352 | 5.0% |
| west | 5414 | 4.2% |
| place | 1949 | 1.5% |
| road | 1522 | 1.2% |
| boulevard | 1214 | 0.9% |
| 5 | 1107 | 0.9% |
| barclay | 711 | 0.6% |
| broadway | 680 | 0.5% |
| Other values (2535) | 63168 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 130535 | |
| 93911 | ||
| T | 80684 | |
| A | 52269 | 7.1% |
| R | 52125 | 7.1% |
| S | 51662 | 7.0% |
| N | 36693 | 5.0% |
| U | 24257 | 3.3% |
| V | 21341 | 2.9% |
| O | 19518 | 2.7% |
| Other values (33) | 170333 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 733328 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 130535 | |
| 93911 | ||
| T | 80684 | |
| A | 52269 | 7.1% |
| R | 52125 | 7.1% |
| S | 51662 | 7.0% |
| N | 36693 | 5.0% |
| U | 24257 | 3.3% |
| V | 21341 | 2.9% |
| O | 19518 | 2.7% |
| Other values (33) | 170333 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 733328 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 130535 | |
| 93911 | ||
| T | 80684 | |
| A | 52269 | 7.1% |
| R | 52125 | 7.1% |
| S | 51662 | 7.0% |
| N | 36693 | 5.0% |
| U | 24257 | 3.3% |
| V | 21341 | 2.9% |
| O | 19518 | 2.7% |
| Other values (33) | 170333 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 733328 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 130535 | |
| 93911 | ||
| T | 80684 | |
| A | 52269 | 7.1% |
| R | 52125 | 7.1% |
| S | 51662 | 7.0% |
| N | 36693 | 5.0% |
| U | 24257 | 3.3% |
| V | 21341 | 2.9% |
| O | 19518 | 2.7% |
| Other values (33) | 170333 |
Missing 
| Distinct | 3949 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 4068 |
| Missing (%) | 6.9% |
| Memory size | 460.4 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.447698 |
| Min length | 4 |
Unique
| Unique | 915 ? |
|---|---|
| Unique (%) | 1.7% |
Sample
| 1st row | BRIGHTON 6 STREET |
|---|---|
| 2nd row | PELHAM PARKWAY SOUTH |
| 3rd row | BROADWAY |
| 4th row | MIKE LEE |
| 5th row | LANCASTER AVENUE |
| Value | Count | Frequency (%) |
| street | 27982 | |
| avenue | 17471 | 13.6% |
| east | 6350 | 5.0% |
| west | 5696 | 4.4% |
| place | 2008 | 1.6% |
| road | 1833 | 1.4% |
| boulevard | 1149 | 0.9% |
| sanford | 734 | 0.6% |
| broadway | 723 | 0.6% |
| 3 | 647 | 0.5% |
| Other values (2513) | 63679 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 129948 | |
| 94721 | ||
| T | 81605 | |
| S | 52921 | 7.2% |
| R | 52178 | 7.1% |
| A | 51241 | 6.9% |
| N | 38679 | 5.2% |
| U | 24047 | 3.3% |
| O | 22091 | 3.0% |
| V | 21172 | 2.9% |
| Other values (33) | 168936 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 737539 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 129948 | |
| 94721 | ||
| T | 81605 | |
| S | 52921 | 7.2% |
| R | 52178 | 7.1% |
| A | 51241 | 6.9% |
| N | 38679 | 5.2% |
| U | 24047 | 3.3% |
| O | 22091 | 3.0% |
| V | 21172 | 2.9% |
| Other values (33) | 168936 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 737539 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 129948 | |
| 94721 | ||
| T | 81605 | |
| S | 52921 | 7.2% |
| R | 52178 | 7.1% |
| A | 51241 | 6.9% |
| N | 38679 | 5.2% |
| U | 24047 | 3.3% |
| O | 22091 | 3.0% |
| V | 21172 | 2.9% |
| Other values (33) | 168936 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 737539 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 129948 | |
| 94721 | ||
| T | 81605 | |
| S | 52921 | 7.2% |
| R | 52178 | 7.1% |
| A | 51241 | 6.9% |
| N | 38679 | 5.2% |
| U | 24047 | 3.3% |
| O | 22091 | 3.0% |
| V | 21172 | 2.9% |
| Other values (33) | 168936 |
address_type
Categorical
Imbalance  Missing 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1949 |
| Missing (%) | 3.3% |
| Memory size | 460.4 KiB |
| ADDRESS | |
|---|---|
| LATLONG | 805 |
| INTERSECTION | 735 |
| UNRECOGNIZED | 123 |
| BLOCKFACE | 35 |
Length
| Max length | 12 |
|---|---|
| Median length | 7 |
| Mean length | 7.0766449 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ADDRESS |
|---|---|
| 2nd row | ADDRESS |
| 3rd row | ADDRESS |
| 4th row | ADDRESS |
| 5th row | ADDRESS |
Common Values
| Value | Count | Frequency (%) |
| ADDRESS | 55263 | |
| LATLONG | 805 | 1.4% |
| INTERSECTION | 735 | 1.2% |
| UNRECOGNIZED | 123 | 0.2% |
| BLOCKFACE | 35 | 0.1% |
| PLACENAME | 3 | < 0.1% |
| (Missing) | 1949 | 3.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| address | 55263 | |
| latlong | 805 | 1.4% |
| intersection | 735 | 1.3% |
| unrecognized | 123 | 0.2% |
| blockface | 35 | 0.1% |
| placename | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 111261 | |
| D | 110649 | |
| E | 57020 | |
| R | 56121 | |
| A | 56109 | |
| N | 2524 | 0.6% |
| T | 2275 | 0.6% |
| O | 1698 | 0.4% |
| L | 1648 | 0.4% |
| I | 1593 | 0.4% |
| Other values (9) | 2216 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 403114 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 111261 | |
| D | 110649 | |
| E | 57020 | |
| R | 56121 | |
| A | 56109 | |
| N | 2524 | 0.6% |
| T | 2275 | 0.6% |
| O | 1698 | 0.4% |
| L | 1648 | 0.4% |
| I | 1593 | 0.4% |
| Other values (9) | 2216 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 403114 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 111261 | |
| D | 110649 | |
| E | 57020 | |
| R | 56121 | |
| A | 56109 | |
| N | 2524 | 0.6% |
| T | 2275 | 0.6% |
| O | 1698 | 0.4% |
| L | 1648 | 0.4% |
| I | 1593 | 0.4% |
| Other values (9) | 2216 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 403114 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 111261 | |
| D | 110649 | |
| E | 57020 | |
| R | 56121 | |
| A | 56109 | |
| N | 2524 | 0.6% |
| T | 2275 | 0.6% |
| O | 1698 | 0.4% |
| L | 1648 | 0.4% |
| I | 1593 | 0.4% |
| Other values (9) | 2216 | 0.5% |
city
Text
Missing 
| Distinct | 56 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2100 |
| Missing (%) | 3.6% |
| Memory size | 460.4 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 8 |
| Mean length | 8.4094485 |
| Min length | 2 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | BRONX |
| 3rd row | NEW YORK |
| 4th row | Brooklyn |
| 5th row | BROOKLYN |
| Value | Count | Frequency (%) |
| new | 19424 | |
| york | 19410 | |
| brooklyn | 15888 | |
| bronx | 5705 | 6.7% |
| island | 2938 | 3.4% |
| staten | 2377 | 2.8% |
| flushing | 2211 | 2.6% |
| astoria | 1591 | 1.9% |
| jamaica | 1246 | 1.5% |
| park | 823 | 1.0% |
| Other values (52) | 13712 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 67492 | |
| N | 53053 | |
| R | 48319 | |
| K | 37347 | 7.8% |
| Y | 36611 | 7.7% |
| E | 29866 | 6.3% |
| 28512 | 6.0% | |
| L | 26898 | 5.6% |
| B | 22255 | 4.7% |
| W | 21490 | 4.5% |
| Other values (38) | 105923 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 477766 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 67492 | |
| N | 53053 | |
| R | 48319 | |
| K | 37347 | 7.8% |
| Y | 36611 | 7.7% |
| E | 29866 | 6.3% |
| 28512 | 6.0% | |
| L | 26898 | 5.6% |
| B | 22255 | 4.7% |
| W | 21490 | 4.5% |
| Other values (38) | 105923 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 477766 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 67492 | |
| N | 53053 | |
| R | 48319 | |
| K | 37347 | 7.8% |
| Y | 36611 | 7.7% |
| E | 29866 | 6.3% |
| 28512 | 6.0% | |
| L | 26898 | 5.6% |
| B | 22255 | 4.7% |
| W | 21490 | 4.5% |
| Other values (38) | 105923 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 477766 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 67492 | |
| N | 53053 | |
| R | 48319 | |
| K | 37347 | 7.8% |
| Y | 36611 | 7.7% |
| E | 29866 | 6.3% |
| 28512 | 6.0% | |
| L | 26898 | 5.6% |
| B | 22255 | 4.7% |
| W | 21490 | 4.5% |
| Other values (38) | 105923 |
landmark
Text
Missing 
| Distinct | 2080 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 7431 |
| Missing (%) | 12.6% |
| Memory size | 460.4 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 13.424556 |
| Min length | 6 |
Unique
| Unique | 537 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | BRIGHTON BEACH AVENUE |
|---|---|
| 2nd row | WILLIAMSBRIDGE ROAD |
| 3rd row | WEST 32 STREET |
| 4th row | CONEY ISLAND AVENUE |
| 5th row | PROSPECT PARK WEST |
| Value | Count | Frequency (%) |
| avenue | 24476 | |
| street | 15759 | 14.0% |
| boulevard | 4514 | 4.0% |
| east | 3572 | 3.2% |
| west | 3272 | 2.9% |
| broadway | 2203 | 2.0% |
| road | 1744 | 1.6% |
| 3 | 1267 | 1.1% |
| 8 | 962 | 0.9% |
| 5 | 891 | 0.8% |
| Other values (1359) | 53752 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 115202 | |
| 71719 | ||
| A | 61195 | 8.9% |
| T | 56125 | 8.1% |
| N | 46278 | 6.7% |
| R | 45270 | 6.6% |
| S | 38258 | 5.5% |
| U | 36657 | 5.3% |
| V | 31459 | 4.6% |
| O | 26530 | 3.8% |
| Other values (28) | 162430 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 691123 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 115202 | |
| 71719 | ||
| A | 61195 | 8.9% |
| T | 56125 | 8.1% |
| N | 46278 | 6.7% |
| R | 45270 | 6.6% |
| S | 38258 | 5.5% |
| U | 36657 | 5.3% |
| V | 31459 | 4.6% |
| O | 26530 | 3.8% |
| Other values (28) | 162430 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 691123 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 115202 | |
| 71719 | ||
| A | 61195 | 8.9% |
| T | 56125 | 8.1% |
| N | 46278 | 6.7% |
| R | 45270 | 6.6% |
| S | 38258 | 5.5% |
| U | 36657 | 5.3% |
| V | 31459 | 4.6% |
| O | 26530 | 3.8% |
| Other values (28) | 162430 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 691123 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 115202 | |
| 71719 | ||
| A | 61195 | 8.9% |
| T | 56125 | 8.1% |
| N | 46278 | 6.7% |
| R | 45270 | 6.6% |
| S | 38258 | 5.5% |
| U | 36657 | 5.3% |
| V | 31459 | 4.6% |
| O | 26530 | 3.8% |
| Other values (28) | 162430 |
status
Categorical
High correlation  Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| Closed | |
|---|---|
| In Progress | |
| Unspecified | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.583827 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | In Progress |
|---|---|
| 2nd row | In Progress |
| 3rd row | In Progress |
| 4th row | In Progress |
| 5th row | In Progress |
Common Values
| Value | Count | Frequency (%) |
| Closed | 52034 | |
| In Progress | 6876 | 11.7% |
| Unspecified | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| closed | 52034 | |
| in | 6876 | 10.5% |
| progress | 6876 | 10.5% |
| unspecified | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 65789 | |
| e | 58916 | |
| o | 58910 | |
| d | 52037 | |
| C | 52034 | |
| l | 52034 | |
| r | 13752 | 3.5% |
| n | 6879 | 1.8% |
| I | 6876 | 1.8% |
| 6876 | 1.8% | |
| Other values (7) | 13770 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 387873 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 65789 | |
| e | 58916 | |
| o | 58910 | |
| d | 52037 | |
| C | 52034 | |
| l | 52034 | |
| r | 13752 | 3.5% |
| n | 6879 | 1.8% |
| I | 6876 | 1.8% |
| 6876 | 1.8% | |
| Other values (7) | 13770 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 387873 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 65789 | |
| e | 58916 | |
| o | 58910 | |
| d | 52037 | |
| C | 52034 | |
| l | 52034 | |
| r | 13752 | 3.5% |
| n | 6879 | 1.8% |
| I | 6876 | 1.8% |
| 6876 | 1.8% | |
| Other values (7) | 13770 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 387873 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 65789 | |
| e | 58916 | |
| o | 58910 | |
| d | 52037 | |
| C | 52034 | |
| l | 52034 | |
| r | 13752 | 3.5% |
| n | 6879 | 1.8% |
| I | 6876 | 1.8% |
| 6876 | 1.8% | |
| Other values (7) | 13770 | 3.6% |
community_board
Text
| Distinct | 76 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
Length
| Max length | 25 |
|---|---|
| Median length | 21 |
| Mean length | 10.853479 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 13 BROOKLYN |
|---|---|
| 2nd row | 11 BRONX |
| 3rd row | 05 MANHATTAN |
| 4th row | Unspecified BROOKLYN |
| 5th row | 15 BROOKLYN |
| Value | Count | Frequency (%) |
| manhattan | 19634 | |
| brooklyn | 16056 | |
| queens | 13576 | |
| 01 | 7043 | 5.9% |
| 02 | 5849 | 4.9% |
| bronx | 5782 | 4.8% |
| 07 | 5535 | 4.6% |
| 03 | 5212 | 4.3% |
| 05 | 5012 | 4.2% |
| 04 | 4048 | 3.4% |
| Other values (27) | 32481 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 79486 | 12.4% |
| A | 63706 | 10.0% |
| 61315 | 9.6% | |
| 0 | 48035 | 7.5% |
| T | 44072 | 6.9% |
| O | 37894 | 5.9% |
| E | 29554 | 4.6% |
| 1 | 24060 | 3.8% |
| B | 21838 | 3.4% |
| R | 21838 | 3.4% |
| Other values (27) | 207613 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 639411 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 79486 | 12.4% |
| A | 63706 | 10.0% |
| 61315 | 9.6% | |
| 0 | 48035 | 7.5% |
| T | 44072 | 6.9% |
| O | 37894 | 5.9% |
| E | 29554 | 4.6% |
| 1 | 24060 | 3.8% |
| B | 21838 | 3.4% |
| R | 21838 | 3.4% |
| Other values (27) | 207613 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 639411 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 79486 | 12.4% |
| A | 63706 | 10.0% |
| 61315 | 9.6% | |
| 0 | 48035 | 7.5% |
| T | 44072 | 6.9% |
| O | 37894 | 5.9% |
| E | 29554 | 4.6% |
| 1 | 24060 | 3.8% |
| B | 21838 | 3.4% |
| R | 21838 | 3.4% |
| Other values (27) | 207613 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 639411 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 79486 | 12.4% |
| A | 63706 | 10.0% |
| 61315 | 9.6% | |
| 0 | 48035 | 7.5% |
| T | 44072 | 6.9% |
| O | 37894 | 5.9% |
| E | 29554 | 4.6% |
| 1 | 24060 | 3.8% |
| B | 21838 | 3.4% |
| R | 21838 | 3.4% |
| Other values (27) | 207613 |
bbl
Real number (ℝ)
High correlation  Missing 
| Distinct | 19057 |
|---|---|
| Distinct (%) | 34.7% |
| Missing | 4054 |
| Missing (%) | 6.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5644265 × 109 |
| Minimum | 0 |
|---|---|
| Maximum | 5.2700005 × 109 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.00414 × 109 |
| Q1 | 1.01443 × 109 |
| median | 3.0115 × 109 |
| Q3 | 4.00659 × 109 |
| 95-th percentile | 4.1404801 × 109 |
| Maximum | 5.2700005 × 109 |
| Range | 5.2700005 × 109 |
| Interquartile range (IQR) | 2.99216 × 109 |
Descriptive statistics
| Standard deviation | 1.3009651 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.50731231 |
| Kurtosis | -1.3553835 |
| Mean | 2.5644265 × 109 |
| Median Absolute Deviation (MAD) | 1.0382601 × 109 |
| Skewness | 0.057951962 |
| Sum | 1.4068187 × 1014 |
| Variance | 1.6925102 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4050590011 | 693 | 1.2% |
| 5007350081 | 411 | 0.7% |
| 1015640024 | 146 | 0.2% |
| 4032340173 | 91 | 0.2% |
| 3027790001 | 88 | 0.1% |
| 3033930049 | 85 | 0.1% |
| 1018770031 | 76 | 0.1% |
| 1000917502 | 72 | 0.1% |
| 1010737505 | 69 | 0.1% |
| 3039300028 | 64 | 0.1% |
| Other values (19047) | 53064 | |
| (Missing) | 4054 | 6.9% |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 1000010111 | 1 | < 0.1% |
| 1000020001 | 6 | |
| 1000020002 | 3 | |
| 1000030001 | 3 | |
| 1000047501 | 1 | < 0.1% |
| 1000070027 | 1 | < 0.1% |
| 1000070028 | 3 | |
| 1000070031 | 7 | |
| 1000070035 | 7 |
| Value | Count | Frequency (%) |
| 5270000501 | 2 | |
| 5240009996 | 1 | |
| 5200479999 | 1 | |
| 5080470031 | 1 | |
| 5080470021 | 1 | |
| 5080430019 | 2 | |
| 5080430001 | 2 | |
| 5080340100 | 1 | |
| 5080260016 | 2 | |
| 5080260008 | 1 |
borough
Categorical
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| MANHATTAN | |
|---|---|
| BROOKLYN | |
| QUEENS | |
| BRONX | |
| STATEN ISLAND |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.8566361 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | BRONX |
| 3rd row | MANHATTAN |
| 4th row | BROOKLYN |
| 5th row | BROOKLYN |
Common Values
| Value | Count | Frequency (%) |
| MANHATTAN | 19639 | |
| BROOKLYN | 16056 | |
| QUEENS | 13575 | |
| BRONX | 5778 | 9.8% |
| STATEN ISLAND | 2402 | 4.1% |
| Unspecified | 1463 | 2.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manhattan | 19639 | |
| brooklyn | 16056 | |
| queens | 13575 | |
| bronx | 5778 | 9.4% |
| staten | 2402 | 3.9% |
| island | 2402 | 3.9% |
| unspecified | 1463 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 462858 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 462858 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 462858 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
x_coordinate_state_plane
Real number (ℝ)
High correlation  Missing 
| Distinct | 20541 |
|---|---|
| Distinct (%) | 35.8% |
| Missing | 1566 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1001122.7 |
| Minimum | 914084 |
|---|---|
| Maximum | 1067128 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | 914084 |
|---|---|
| 5-th percentile | 976433 |
| Q1 | 987769 |
| median | 997470 |
| Q3 | 1013515 |
| 95-th percentile | 1038929.2 |
| Maximum | 1067128 |
| Range | 153044 |
| Interquartile range (IQR) | 25746 |
Descriptive statistics
| Standard deviation | 21552.248 |
|---|---|
| Coefficient of variation (CV) | 0.021528079 |
| Kurtosis | 1.1354908 |
| Mean | 1001122.7 |
| Median Absolute Deviation (MAD) | 11185 |
| Skewness | 0.0047316847 |
| Sum | 5.7411382 × 1010 |
| Variance | 4.644994 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1035940 | 694 | 1.2% |
| 946124 | 296 | 0.5% |
| 998687 | 155 | 0.3% |
| 1026862 | 91 | 0.2% |
| 997787 | 88 | 0.1% |
| 982367 | 82 | 0.1% |
| 946097 | 77 | 0.1% |
| 993651 | 75 | 0.1% |
| 985799 | 69 | 0.1% |
| 1017293 | 64 | 0.1% |
| Other values (20531) | 55656 | |
| (Missing) | 1566 | 2.7% |
| Value | Count | Frequency (%) |
| 914084 | 2 | |
| 914381 | 1 | < 0.1% |
| 914616 | 4 | |
| 914856 | 1 | < 0.1% |
| 915031 | 2 | |
| 915092 | 1 | < 0.1% |
| 915172 | 3 | |
| 915191 | 1 | < 0.1% |
| 915252 | 1 | < 0.1% |
| 915470 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1067128 | 1 | < 0.1% |
| 1066911 | 1 | < 0.1% |
| 1066626 | 2 | |
| 1066623 | 1 | < 0.1% |
| 1066615 | 1 | < 0.1% |
| 1066613 | 3 | |
| 1066604 | 1 | < 0.1% |
| 1066596 | 1 | < 0.1% |
| 1066589 | 2 | |
| 1066413 | 1 | < 0.1% |
y_coordinate_state_plane
Real number (ℝ)
High correlation  Missing 
| Distinct | 22040 |
|---|---|
| Distinct (%) | 38.4% |
| Missing | 1564 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 204170.52 |
| Minimum | 121374 |
|---|---|
| Maximum | 271861 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | 121374 |
|---|---|
| 5-th percentile | 158344.8 |
| Q1 | 187605 |
| median | 205155 |
| Q3 | 218497 |
| 95-th percentile | 250186.2 |
| Maximum | 271861 |
| Range | 150487 |
| Interquartile range (IQR) | 30892 |
Descriptive statistics
| Standard deviation | 26241.341 |
|---|---|
| Coefficient of variation (CV) | 0.12852659 |
| Kurtosis | -0.17784387 |
| Mean | 204170.52 |
| Median Absolute Deviation (MAD) | 15484 |
| Skewness | -0.085459416 |
| Sum | 1.1708975 × 1010 |
| Variance | 6.8860797 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 216775 | 694 | 1.2% |
| 162287 | 300 | 0.5% |
| 221604 | 146 | 0.2% |
| 201883 | 92 | 0.2% |
| 198444 | 88 | 0.1% |
| 162281 | 77 | 0.1% |
| 230741 | 75 | 0.1% |
| 197857 | 71 | 0.1% |
| 216568 | 69 | 0.1% |
| 188272 | 66 | 0.1% |
| Other values (22030) | 55671 | |
| (Missing) | 1564 | 2.7% |
| Value | Count | Frequency (%) |
| 121374 | 1 | < 0.1% |
| 124349 | 1 | < 0.1% |
| 124868 | 1 | < 0.1% |
| 125016 | 1 | < 0.1% |
| 125152 | 1 | < 0.1% |
| 125358 | 1 | < 0.1% |
| 125376 | 1 | < 0.1% |
| 125422 | 6 | |
| 125508 | 1 | < 0.1% |
| 125513 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 271861 | 4 | |
| 271054 | 1 | < 0.1% |
| 271005 | 2 | < 0.1% |
| 270768 | 3 | < 0.1% |
| 270176 | 1 | < 0.1% |
| 270038 | 1 | < 0.1% |
| 269885 | 2 | < 0.1% |
| 269699 | 1 | < 0.1% |
| 269605 | 8 | |
| 269588 | 2 | < 0.1% |
open_data_channel_type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| ONLINE | |
|---|---|
| PHONE | |
| MOBILE | |
| UNKNOWN | 28 |
| OTHER | 4 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.6297252 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PHONE |
|---|---|
| 2nd row | PHONE |
| 3rd row | PHONE |
| 4th row | ONLINE |
| 5th row | MOBILE |
Common Values
| Value | Count | Frequency (%) |
| ONLINE | 24195 | |
| PHONE | 21838 | |
| MOBILE | 12848 | |
| UNKNOWN | 28 | < 0.1% |
| OTHER | 4 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 24195 | |
| phone | 21838 | |
| mobile | 12848 | |
| unknown | 28 | < 0.1% |
| other | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 70312 | |
| O | 58913 | |
| E | 58885 | |
| L | 37043 | |
| I | 37043 | |
| H | 21842 | 6.6% |
| P | 21838 | 6.6% |
| M | 12848 | 3.9% |
| B | 12848 | 3.9% |
| U | 28 | < 0.1% |
| Other values (4) | 64 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 331664 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 70312 | |
| O | 58913 | |
| E | 58885 | |
| L | 37043 | |
| I | 37043 | |
| H | 21842 | 6.6% |
| P | 21838 | 6.6% |
| M | 12848 | 3.9% |
| B | 12848 | 3.9% |
| U | 28 | < 0.1% |
| Other values (4) | 64 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 331664 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 70312 | |
| O | 58913 | |
| E | 58885 | |
| L | 37043 | |
| I | 37043 | |
| H | 21842 | 6.6% |
| P | 21838 | 6.6% |
| M | 12848 | 3.9% |
| B | 12848 | 3.9% |
| U | 28 | < 0.1% |
| Other values (4) | 64 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 331664 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 70312 | |
| O | 58913 | |
| E | 58885 | |
| L | 37043 | |
| I | 37043 | |
| H | 21842 | 6.6% |
| P | 21838 | 6.6% |
| M | 12848 | 3.9% |
| B | 12848 | 3.9% |
| U | 28 | < 0.1% |
| Other values (4) | 64 | < 0.1% |
park_facility_name
Categorical
Imbalance 
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| Unspecified | |
|---|---|
| MORRIS PARK BAKE SHOP | 4 |
| SALSA CON FUEGO | 1 |
| PARISI BAKERY | 1 |
| DJ REYNOLDS PUB AND RESTAURANT | 1 |
| Other values (6) | 6 |
Length
| Max length | 30 |
|---|---|
| Median length | 11 |
| Mean length | 11.001443 |
| Min length | 7 |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Unspecified |
|---|---|
| 2nd row | Unspecified |
| 3rd row | Unspecified |
| 4th row | Unspecified |
| 5th row | Unspecified |
Common Values
| Value | Count | Frequency (%) |
| Unspecified | 58900 | |
| MORRIS PARK BAKE SHOP | 4 | < 0.1% |
| SALSA CON FUEGO | 1 | < 0.1% |
| PARISI BAKERY | 1 | < 0.1% |
| DJ REYNOLDS PUB AND RESTAURANT | 1 | < 0.1% |
| WENDY'S | 1 | < 0.1% |
| LE PAIN QUOTIDIEN | 1 | < 0.1% |
| MCDONALD'S | 1 | < 0.1% |
| HAI SUN RESTAURANT | 1 | < 0.1% |
| MASTER SMOOTHIE | 1 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| unspecified | 58900 | |
| morris | 4 | < 0.1% |
| park | 4 | < 0.1% |
| bake | 4 | < 0.1% |
| shop | 4 | < 0.1% |
| restaurant | 2 | < 0.1% |
| salsa | 1 | < 0.1% |
| fuego | 1 | < 0.1% |
| parisi | 1 | < 0.1% |
| bakery | 1 | < 0.1% |
| Other values (17) | 17 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 117800 | |
| i | 117800 | |
| U | 58906 | |
| s | 58900 | |
| n | 58900 | |
| p | 58900 | |
| c | 58900 | |
| f | 58900 | |
| d | 58900 | |
| 26 | < 0.1% | |
| Other values (23) | 196 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 648128 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 117800 | |
| i | 117800 | |
| U | 58906 | |
| s | 58900 | |
| n | 58900 | |
| p | 58900 | |
| c | 58900 | |
| f | 58900 | |
| d | 58900 | |
| 26 | < 0.1% | |
| Other values (23) | 196 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 648128 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 117800 | |
| i | 117800 | |
| U | 58906 | |
| s | 58900 | |
| n | 58900 | |
| p | 58900 | |
| c | 58900 | |
| f | 58900 | |
| d | 58900 | |
| 26 | < 0.1% | |
| Other values (23) | 196 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 648128 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 117800 | |
| i | 117800 | |
| U | 58906 | |
| s | 58900 | |
| n | 58900 | |
| p | 58900 | |
| c | 58900 | |
| f | 58900 | |
| d | 58900 | |
| 26 | < 0.1% | |
| Other values (23) | 196 | < 0.1% |
park_borough
Categorical
High correlation 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 460.4 KiB |
| MANHATTAN | |
|---|---|
| BROOKLYN | |
| QUEENS | |
| BRONX | |
| STATEN ISLAND |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 7.8566361 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BROOKLYN |
|---|---|
| 2nd row | BRONX |
| 3rd row | MANHATTAN |
| 4th row | BROOKLYN |
| 5th row | BROOKLYN |
Common Values
| Value | Count | Frequency (%) |
| MANHATTAN | 19639 | |
| BROOKLYN | 16056 | |
| QUEENS | 13575 | |
| BRONX | 5778 | 9.8% |
| STATEN ISLAND | 2402 | 4.1% |
| Unspecified | 1463 | 2.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| manhattan | 19639 | |
| brooklyn | 16056 | |
| queens | 13575 | |
| bronx | 5778 | 9.4% |
| staten | 2402 | 3.9% |
| island | 2402 | 3.9% |
| unspecified | 1463 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 462858 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 462858 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 462858 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 79491 | |
| A | 63721 | |
| T | 44082 | |
| O | 37890 | 8.2% |
| E | 29552 | 6.4% |
| B | 21834 | 4.7% |
| R | 21834 | 4.7% |
| H | 19639 | 4.2% |
| M | 19639 | 4.2% |
| L | 18458 | 4.0% |
| Other values (17) | 106718 |
latitude
Real number (ℝ)
High correlation  Missing 
| Distinct | 25732 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 1569 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.727031 |
| Minimum | 40.49957 |
|---|---|
| Maximum | 40.912828 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | 40.49957 |
|---|---|
| 5-th percentile | 40.601295 |
| Q1 | 40.68154 |
| median | 40.729744 |
| Q3 | 40.766347 |
| 95-th percentile | 40.853346 |
| Maximum | 40.912828 |
| Range | 0.41325788 |
| Interquartile range (IQR) | 0.084806712 |
Descriptive statistics
| Standard deviation | 0.072026934 |
|---|---|
| Coefficient of variation (CV) | 0.001768529 |
| Kurtosis | -0.17747501 |
| Mean | 40.727031 |
| Median Absolute Deviation (MAD) | 0.042470068 |
| Skewness | -0.085756609 |
| Sum | 2335450.9 |
| Variance | 0.0051878793 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.76152265 | 694 | 1.2% |
| 40.6120347 | 296 | 0.5% |
| 40.77491631 | 146 | 0.2% |
| 40.72069629 | 91 | 0.2% |
| 40.71134933 | 88 | 0.1% |
| 40.61201811 | 77 | 0.1% |
| 40.80000172 | 75 | 0.1% |
| 40.70974831 | 71 | 0.1% |
| 40.76110546 | 69 | 0.1% |
| 40.68337824 | 64 | 0.1% |
| Other values (25722) | 55673 | |
| (Missing) | 1569 | 2.7% |
| Value | Count | Frequency (%) |
| 40.49956978 | 1 | < 0.1% |
| 40.50775363 | 1 | < 0.1% |
| 40.50914304 | 1 | < 0.1% |
| 40.50954848 | 1 | < 0.1% |
| 40.50992911 | 1 | < 0.1% |
| 40.51049806 | 1 | < 0.1% |
| 40.51054699 | 1 | < 0.1% |
| 40.51067378 | 6 | |
| 40.51091083 | 1 | < 0.1% |
| 40.51092453 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.91282765 | 4 | |
| 40.91060759 | 1 | < 0.1% |
| 40.91047872 | 1 | < 0.1% |
| 40.91047309 | 1 | < 0.1% |
| 40.90982838 | 3 | |
| 40.90820392 | 1 | < 0.1% |
| 40.90782747 | 1 | < 0.1% |
| 40.90740538 | 2 | |
| 40.90689522 | 1 | < 0.1% |
| 40.90659041 | 2 |
longitude
Real number (ℝ)
High correlation  Missing 
| Distinct | 25732 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 1569 |
| Missing (%) | 2.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.939096 |
| Minimum | -74.252343 |
|---|---|
| Maximum | -73.700929 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 57344 |
| Negative (%) | 97.3% |
| Memory size | 460.4 KiB |
Quantile statistics
| Minimum | -74.252343 |
|---|---|
| 5-th percentile | -74.028162 |
| Q1 | -73.987303 |
| median | -73.952337 |
| Q3 | -73.894381 |
| 95-th percentile | -73.802681 |
| Maximum | -73.700929 |
| Range | 0.55141369 |
| Interquartile range (IQR) | 0.092922131 |
Descriptive statistics
| Standard deviation | 0.0777343 |
|---|---|
| Coefficient of variation (CV) | -0.0010513288 |
| Kurtosis | 1.1247575 |
| Mean | -73.939096 |
| Median Absolute Deviation (MAD) | 0.040367762 |
| Skewness | 0.0074441299 |
| Sum | -4239963.5 |
| Variance | 0.0060426214 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.81341016 | 694 | 1.2% |
| -74.13731846 | 296 | 0.5% |
| -73.94787507 | 146 | 0.2% |
| -73.84627407 | 91 | 0.2% |
| -73.95117114 | 88 | 0.1% |
| -74.13741567 | 77 | 0.1% |
| -73.96604481 | 75 | 0.1% |
| -74.00679194 | 71 | 0.1% |
| -73.99440848 | 69 | 0.1% |
| -73.88086167 | 64 | 0.1% |
| Other values (25722) | 55673 | |
| (Missing) | 1569 | 2.7% |
| Value | Count | Frequency (%) |
| -74.25234297 | 2 | |
| -74.2512771 | 1 | < 0.1% |
| -74.25043315 | 4 | |
| -74.24956219 | 1 | < 0.1% |
| -74.24893041 | 2 | |
| -74.24871018 | 1 | < 0.1% |
| -74.24843668 | 3 | |
| -74.24836242 | 1 | < 0.1% |
| -74.24814344 | 1 | < 0.1% |
| -74.24734551 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.70092928 | 1 | < 0.1% |
| -73.70171308 | 1 | < 0.1% |
| -73.70268276 | 2 | |
| -73.70269361 | 1 | < 0.1% |
| -73.70272256 | 1 | < 0.1% |
| -73.7027297 | 3 | |
| -73.70276236 | 1 | < 0.1% |
| -73.70279129 | 1 | < 0.1% |
| -73.70281653 | 2 | |
| -73.70351185 | 1 | < 0.1% |
location
Text
Missing 
| Distinct | 25732 |
|---|---|
| Distinct (%) | 44.9% |
| Missing | 1569 |
| Missing (%) | 2.7% |
| Memory size | 460.4 KiB |
Length
| Max length | 141 |
|---|---|
| Median length | 140 |
| Mean length | 140.06805 |
| Min length | 136 |
Unique
| Unique | 15005 ? |
|---|---|
| Unique (%) | 26.2% |
Sample
| 1st row | {'latitude': '40.577479337191384', 'longitude': '-73.9620829225648', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
|---|---|
| 2nd row | {'latitude': '40.8558288801221', 'longitude': '-73.85555931275691', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 3rd row | {'latitude': '40.74758418018265', 'longitude': '-73.9864914082603', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 4th row | {'latitude': '40.71827775344117', 'longitude': '-73.959946580784', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| 5th row | {'latitude': '40.59326974931518', 'longitude': '-73.9607993127448', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} |
| Value | Count | Frequency (%) |
| 229376 | ||
| latitude | 57344 | 7.7% |
| longitude | 57344 | 7.7% |
| human_address | 57344 | 7.7% |
| state | 57344 | 7.7% |
| address | 57344 | 7.7% |
| city | 57344 | 7.7% |
| zip | 57344 | 7.7% |
| 73.81341016404748 | 694 | 0.1% |
| 40.76152264872703 | 694 | 0.1% |
| Other values (51462) | 113300 |
Most occurring characters
| Value | Count | Frequency (%) |
| " | 917504 | 11.4% |
| ' | 688128 | 8.6% |
| 688128 | 8.6% | |
| : | 401408 | 5.0% |
| d | 344064 | 4.3% |
| t | 344064 | 4.3% |
| , | 286720 | 3.6% |
| e | 286720 | 3.6% |
| s | 286720 | 3.6% |
| a | 286720 | 3.6% |
| Other values (28) | 3501886 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8032062 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| " | 917504 | 11.4% |
| ' | 688128 | 8.6% |
| 688128 | 8.6% | |
| : | 401408 | 5.0% |
| d | 344064 | 4.3% |
| t | 344064 | 4.3% |
| , | 286720 | 3.6% |
| e | 286720 | 3.6% |
| s | 286720 | 3.6% |
| a | 286720 | 3.6% |
| Other values (28) | 3501886 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8032062 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| " | 917504 | 11.4% |
| ' | 688128 | 8.6% |
| 688128 | 8.6% | |
| : | 401408 | 5.0% |
| d | 344064 | 4.3% |
| t | 344064 | 4.3% |
| , | 286720 | 3.6% |
| e | 286720 | 3.6% |
| s | 286720 | 3.6% |
| a | 286720 | 3.6% |
| Other values (28) | 3501886 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8032062 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| " | 917504 | 11.4% |
| ' | 688128 | 8.6% |
| 688128 | 8.6% | |
| : | 401408 | 5.0% |
| d | 344064 | 4.3% |
| t | 344064 | 4.3% |
| , | 286720 | 3.6% |
| e | 286720 | 3.6% |
| s | 286720 | 3.6% |
| a | 286720 | 3.6% |
| Other values (28) | 3501886 |
closed_date
Date
Missing 
| Distinct | 49129 |
|---|---|
| Distinct (%) | 94.4% |
| Missing | 6875 |
| Missing (%) | 11.7% |
| Memory size | 460.4 KiB |
| Minimum | 2019-01-25 10:20:32 |
|---|---|
| Maximum | 2024-09-23 12:59:03 |
resolution_description
Categorical
High correlation  Imbalance  Missing 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 5769 |
| Missing (%) | 9.8% |
| Memory size | 460.4 KiB |
| This SR was administratively closed. The issue you reported was addressed. | |
|---|---|
| The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2121 |
| The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 1518 |
| The Department of Health and Mental Hygiene has reviewed your Service Request. A warning letter has been sent to the responsible party notifying them to correct the condition. An inspector will be dispatched if needed. If the condition persists 21 days after the initial report, please call 311 to file another Service Request. | 398 |
| The Department of Health and Mental Hygiene has sent an official warning to the establishment. If the situation persists 45 days after the initial report, call 311 and file a new Service Reqeust. | 28 |
| Other values (10) | 44 |
Length
| Max length | 495 |
|---|---|
| Median length | 74 |
| Mean length | 90.328899 |
| Min length | 74 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | This SR was administratively closed. The issue you reported was addressed. |
|---|---|
| 2nd row | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. |
| 3rd row | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. |
| 4th row | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. |
| 5th row | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. |
Common Values
| Value | Count | Frequency (%) |
| This SR was administratively closed. The issue you reported was addressed. | 49035 | |
| The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2121 | 3.6% |
| The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 1518 | 2.6% |
| The Department of Health and Mental Hygiene has reviewed your Service Request. A warning letter has been sent to the responsible party notifying them to correct the condition. An inspector will be dispatched if needed. If the condition persists 21 days after the initial report, please call 311 to file another Service Request. | 398 | 0.7% |
| The Department of Health and Mental Hygiene has sent an official warning to the establishment. If the situation persists 45 days after the initial report, call 311 and file a new Service Reqeust. | 28 | < 0.1% |
| The Department of Health and Mental Hygiene regulates restaurants and other establishments that mostly sell food which is prepared on the premises. New York State Agriculture and Markets regulates those establishments that mostly sell pre-packaged food, including supermarkets, bodegas, green markets, fish and meat markets, and delis. This Service Request involves an establishment under the jurisdiction of the New York State Agriculture and Markets. For complaint status, call (718) 722-2876. | 13 | < 0.1% |
| The Department of Health and Mental Hygiene has determined that this issue is not within its jurisdiction; it cannot be determined if another agency would regulate the issue reported. This Service Request has been closed. | 10 | < 0.1% |
| The Department of Health and Mental Hygiene has investigated the complaint. No violations were cited and no further action will be taken. | 7 | < 0.1% |
| The Department of Health and Mental Hygiene has investigated the complaint. No violations were cited and no further action will be taken. | 5 | < 0.1% |
| The Department of Health and Mental Hygiene has investigated the complaint and issued a Notice of Violation. No further action will be taken. | 2 | < 0.1% |
| Other values (5) | 7 | < 0.1% |
| (Missing) | 5769 | 9.8% |
Length
| Value | Count | Frequency (%) |
| was | 98072 | |
| the | 65816 | |
| this | 49068 | 6.9% |
| issue | 49055 | 6.9% |
| closed | 49048 | 6.9% |
| reported | 49045 | 6.9% |
| administratively | 49035 | 6.8% |
| sr | 49035 | 6.8% |
| you | 49035 | 6.8% |
| addressed | 49035 | 6.8% |
| Other values (116) | 159724 |
Most occurring characters
| Value | Count | Frequency (%) |
| 664955 | ||
| e | 495432 | 10.3% |
| s | 487857 | 10.2% |
| i | 338213 | 7.0% |
| a | 332442 | 6.9% |
| d | 316448 | 6.6% |
| t | 272980 | 5.7% |
| r | 243640 | 5.1% |
| o | 215543 | 4.5% |
| n | 141707 | 3.0% |
| Other values (45) | 1291222 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4800439 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 664955 | ||
| e | 495432 | 10.3% |
| s | 487857 | 10.2% |
| i | 338213 | 7.0% |
| a | 332442 | 6.9% |
| d | 316448 | 6.6% |
| t | 272980 | 5.7% |
| r | 243640 | 5.1% |
| o | 215543 | 4.5% |
| n | 141707 | 3.0% |
| Other values (45) | 1291222 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4800439 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 664955 | ||
| e | 495432 | 10.3% |
| s | 487857 | 10.2% |
| i | 338213 | 7.0% |
| a | 332442 | 6.9% |
| d | 316448 | 6.6% |
| t | 272980 | 5.7% |
| r | 243640 | 5.1% |
| o | 215543 | 4.5% |
| n | 141707 | 3.0% |
| Other values (45) | 1291222 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4800439 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 664955 | ||
| e | 495432 | 10.3% |
| s | 487857 | 10.2% |
| i | 338213 | 7.0% |
| a | 332442 | 6.9% |
| d | 316448 | 6.6% |
| t | 272980 | 5.7% |
| r | 243640 | 5.1% |
| o | 215543 | 4.5% |
| n | 141707 | 3.0% |
| Other values (45) | 1291222 |
resolution_action_updated_date
Date
Missing 
| Distinct | 37308 |
|---|---|
| Distinct (%) | 70.2% |
| Missing | 5769 |
| Missing (%) | 9.8% |
| Memory size | 460.4 KiB |
| Minimum | 2019-01-25 10:20:32 |
|---|---|
| Maximum | 2024-09-23 12:59:05 |
due_date
Date
Missing 
| Distinct | 5235 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 53677 |
| Missing (%) | 91.1% |
| Memory size | 460.4 KiB |
| Minimum | 2019-01-25 09:31:31 |
|---|---|
| Maximum | 2019-08-26 15:46:45 |
facility_type
Unsupported
Missing  Rejected  Unsupported 
| Missing | 58913 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 460.4 KiB |
Interactions
Correlations
| address_type | bbl | borough | descriptor | incident_zip | latitude | location_type | longitude | open_data_channel_type | park_borough | park_facility_name | resolution_description | status | unique_key | x_coordinate_state_plane | y_coordinate_state_plane | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| address_type | 1.000 | 0.100 | 0.015 | 0.065 | 0.041 | 0.029 | 0.066 | 0.026 | 0.122 | 0.015 | 0.000 | 0.110 | 0.037 | 0.165 | 0.026 | 0.029 |
| bbl | 0.100 | 1.000 | 0.894 | 0.069 | 0.842 | -0.412 | 0.021 | 0.496 | 0.073 | 0.894 | 0.000 | 0.008 | 0.031 | -0.046 | 0.496 | -0.411 |
| borough | 0.015 | 0.894 | 1.000 | 0.092 | 0.685 | 0.561 | 0.029 | 0.609 | 0.117 | 1.000 | 0.005 | 0.029 | 0.038 | 0.093 | 0.609 | 0.562 |
| descriptor | 0.065 | 0.069 | 0.092 | 1.000 | 0.074 | 0.062 | 0.074 | 0.067 | 0.197 | 0.092 | 0.000 | 0.091 | 0.082 | 0.098 | 0.067 | 0.062 |
| incident_zip | 0.041 | 0.842 | 0.685 | 0.074 | 1.000 | -0.374 | 0.025 | 0.624 | 0.073 | 0.685 | 0.000 | 0.009 | 0.027 | -0.021 | 0.625 | -0.374 |
| latitude | 0.029 | -0.412 | 0.561 | 0.062 | -0.374 | 1.000 | 0.022 | 0.326 | 0.072 | 0.561 | 0.000 | 0.014 | 0.027 | 0.010 | 0.325 | 1.000 |
| location_type | 0.066 | 0.021 | 0.029 | 0.074 | 0.025 | 0.022 | 1.000 | 0.032 | 0.149 | 0.029 | 0.011 | 0.052 | 0.049 | 0.204 | 0.032 | 0.022 |
| longitude | 0.026 | 0.496 | 0.609 | 0.067 | 0.624 | 0.326 | 0.032 | 1.000 | 0.082 | 0.609 | 0.000 | 0.009 | 0.034 | -0.020 | 1.000 | 0.326 |
| open_data_channel_type | 0.122 | 0.073 | 0.117 | 0.197 | 0.073 | 0.072 | 0.149 | 0.082 | 1.000 | 0.117 | 0.000 | 0.040 | 0.039 | 0.095 | 0.081 | 0.072 |
| park_borough | 0.015 | 0.894 | 1.000 | 0.092 | 0.685 | 0.561 | 0.029 | 0.609 | 0.117 | 1.000 | 0.005 | 0.029 | 0.038 | 0.093 | 0.609 | 0.562 |
| park_facility_name | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.011 | 0.000 | 0.000 | 0.005 | 1.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 |
| resolution_description | 0.110 | 0.008 | 0.029 | 0.091 | 0.009 | 0.014 | 0.052 | 0.009 | 0.040 | 0.029 | 0.000 | 1.000 | 0.601 | 0.282 | 0.009 | 0.014 |
| status | 0.037 | 0.031 | 0.038 | 0.082 | 0.027 | 0.027 | 0.049 | 0.034 | 0.039 | 0.038 | 0.000 | 0.601 | 1.000 | 0.653 | 0.034 | 0.027 |
| unique_key | 0.165 | -0.046 | 0.093 | 0.098 | -0.021 | 0.010 | 0.204 | -0.020 | 0.095 | 0.093 | 0.006 | 0.282 | 0.653 | 1.000 | -0.020 | 0.010 |
| x_coordinate_state_plane | 0.026 | 0.496 | 0.609 | 0.067 | 0.625 | 0.325 | 0.032 | 1.000 | 0.081 | 0.609 | 0.000 | 0.009 | 0.034 | -0.020 | 1.000 | 0.326 |
| y_coordinate_state_plane | 0.029 | -0.411 | 0.562 | 0.062 | -0.374 | 1.000 | 0.022 | 0.326 | 0.072 | 0.562 | 0.000 | 0.014 | 0.027 | 0.010 | 0.326 | 1.000 |
Missing values
Sample
| unique_key | created_date | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | street_name | cross_street_1 | cross_street_2 | intersection_street_1 | intersection_street_2 | address_type | city | landmark | status | community_board | bbl | borough | x_coordinate_state_plane | y_coordinate_state_plane | open_data_channel_type | park_facility_name | park_borough | latitude | longitude | location | closed_date | resolution_description | resolution_action_updated_date | due_date | facility_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 62605571 | 2024-09-29T23:42:42.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Bare Hands in Contact w/ Food | Restaurant/Bar/Deli/Bakery | 11235.0 | 523 BRIGHTON BEACH AVENUE | BRIGHTON BEACH AVENUE | BRIGHTON 5 STREET | BRIGHTON 6 STREET | BRIGHTON 5 STREET | BRIGHTON 6 STREET | ADDRESS | BROOKLYN | BRIGHTON BEACH AVENUE | In Progress | 13 BROOKLYN | 3.086750e+09 | BROOKLYN | 994783.0 | 149670.0 | PHONE | Unspecified | BROOKLYN | 40.577479 | -73.962083 | {'latitude': '40.577479337191384', 'longitude': '-73.9620829225648', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 1 | 62601936 | 2024-09-29T21:52:07.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 10461.0 | 2117 WILLIAMBRIDGE ROAD | WILLIAMBRIDGE ROAD | LYDIG AVENUE | PELHAM PARKWAY SOUTH | LYDIG AVENUE | PELHAM PARKWAY SOUTH | ADDRESS | BRONX | WILLIAMSBRIDGE ROAD | In Progress | 11 BRONX | 2.043320e+09 | BRONX | 1024207.0 | 251112.0 | PHONE | Unspecified | BRONX | 40.855829 | -73.855559 | {'latitude': '40.8558288801221', 'longitude': '-73.85555931275691', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 2 | 62602735 | 2024-09-29T21:22:45.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 10001.0 | 31 WEST 32 STREET | WEST 32 STREET | 5 AVENUE | BROADWAY | 5 AVENUE | BROADWAY | ADDRESS | NEW YORK | WEST 32 STREET | In Progress | 05 MANHATTAN | 1.008340e+09 | MANHATTAN | 987993.0 | 211642.0 | PHONE | Unspecified | MANHATTAN | 40.747584 | -73.986491 | {'latitude': '40.74758418018265', 'longitude': '-73.9864914082603', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 3 | 62605500 | 2024-09-29T21:14:24.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | NaN | 114 | NaN | BERRY STRE | MIKE LEE | BERRY STRE | MIKE LEE | NaN | Brooklyn | NaN | In Progress | Unspecified BROOKLYN | 3.023340e+09 | BROOKLYN | 995353.0 | 200967.0 | ONLINE | Unspecified | BROOKLYN | 40.718278 | -73.959947 | {'latitude': '40.71827775344117', 'longitude': '-73.959946580784', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 4 | 62603635 | 2024-09-29T21:05:25.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Bare Hands in Contact w/ Food | Restaurant/Bar/Deli/Bakery | 11223.0 | 2605 CONEY ISLAND AVENUE | CONEY ISLAND AVENUE | AVENUE W | LANCASTER AVENUE | AVENUE W | LANCASTER AVENUE | ADDRESS | BROOKLYN | CONEY ISLAND AVENUE | In Progress | 15 BROOKLYN | 3.073940e+09 | BROOKLYN | 995137.0 | 155423.0 | MOBILE | Unspecified | BROOKLYN | 40.593270 | -73.960799 | {'latitude': '40.59326974931518', 'longitude': '-73.9607993127448', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 5 | 62603805 | 2024-09-29T19:26:50.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 11215.0 | 192 PROSPECT PARK WEST | PROSPECT PARK WEST | NaN | 15 STREET | NaN | 15 STREET | ADDRESS | BROOKLYN | PROSPECT PARK WEST | In Progress | 06 BROOKLYN | 3.011030e+09 | BROOKLYN | 989873.0 | 180198.0 | MOBILE | Unspecified | BROOKLYN | 40.661277 | -73.979733 | {'latitude': '40.661276811907456', 'longitude': '-73.9797326921662', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 6 | 62602734 | 2024-09-29T19:16:42.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | No Permit or License | Restaurant/Bar/Deli/Bakery | 11417.0 | 93-10 LIBERTY AVENUE | LIBERTY AVENUE | 93 STREET | 94 STREET | 93 STREET | 94 STREET | ADDRESS | OZONE PARK | LIBERTY AVENUE | In Progress | 10 QUEENS | 4.091620e+09 | QUEENS | 1027054.0 | 187128.0 | MOBILE | Unspecified | QUEENS | 40.680196 | -73.845675 | {'latitude': '40.68019640487362', 'longitude': '-73.84567519025673', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 7 | 62602005 | 2024-09-29T17:55:03.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 10014.0 | 567 HUDSON STREET | HUDSON STREET | PERRY STREET | WEST 11 STREET | PERRY STREET | WEST 11 STREET | ADDRESS | NEW YORK | HUDSON STREET | In Progress | 02 MANHATTAN | 1.006330e+09 | MANHATTAN | 982591.0 | 207327.0 | ONLINE | Unspecified | MANHATTAN | 40.735741 | -74.005986 | {'latitude': '40.73574121648932', 'longitude': '-74.00598631322032', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 8 | 62606493 | 2024-09-29T17:43:04.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Toilet Facility | Restaurant/Bar/Deli/Bakery | 11209.0 | 9243 4 AVENUE | 4 AVENUE | 93 STREET | 94 STREET | 93 STREET | 94 STREET | ADDRESS | BROOKLYN | 4 AVENUE | In Progress | 10 BROOKLYN | 3.061080e+09 | BROOKLYN | 975770.0 | 164215.0 | PHONE | Unspecified | BROOKLYN | 40.617405 | -74.030545 | {'latitude': '40.61740462322561', 'longitude': '-74.03054487148385', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| 9 | 62604247 | 2024-09-29T16:43:02.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Food Contaminated | Restaurant/Bar/Deli/Bakery | 10038.0 | 164 WILLIAM STREET | WILLIAM STREET | ANN STREET | BEEKMAN STREET | ANN STREET | BEEKMAN STREET | ADDRESS | NEW YORK | WILLIAM STREET | In Progress | 01 MANHATTAN | 1.000930e+09 | MANHATTAN | 982655.0 | 198034.0 | ONLINE | Unspecified | MANHATTAN | 40.710234 | -74.005753 | {'latitude': '40.71023419230766', 'longitude': '-74.00575317413539', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | NaN | NaN | NaN | NaN | NaN |
| unique_key | created_date | agency | agency_name | complaint_type | descriptor | location_type | incident_zip | incident_address | street_name | cross_street_1 | cross_street_2 | intersection_street_1 | intersection_street_2 | address_type | city | landmark | status | community_board | bbl | borough | x_coordinate_state_plane | y_coordinate_state_plane | open_data_channel_type | park_facility_name | park_borough | latitude | longitude | location | closed_date | resolution_description | resolution_action_updated_date | due_date | facility_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58903 | 41318001 | 2019-01-01T12:57:21.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Letter Grading | Restaurant/Bar/Deli/Bakery | 10309.0 | 4864 ARTHUR KIL ROAD | ARTHUR KIL ROAD | SOUTH BRIDGE STREET | RICHMOND VALLEY ROAD | NaN | NaN | ADDRESS | STATEN ISLAND | NaN | Closed | 03 STATEN ISLAND | 5.075840e+09 | STATEN ISLAND | 917747.0 | 130119.0 | PHONE | Unspecified | STATEN ISLAND | 40.523573 | -74.239207 | {'latitude': '40.5235725885887', 'longitude': '-74.23920715187802', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:15.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:16.000 | 2019-03-02T12:57:21.000 | NaN |
| 58904 | 41314982 | 2019-01-01T12:18:43.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Food Spoiled | Restaurant/Bar/Deli/Bakery | 11368.0 | 96-23 57 AVENUE | 57 AVENUE | 96 STREET | 97 STREET | NaN | NaN | ADDRESS | CORONA | NaN | Closed | 04 QUEENS | 4.019040e+09 | QUEENS | 1021789.0 | 207822.0 | PHONE | Unspecified | QUEENS | 40.737020 | -73.864542 | {'latitude': '40.73702035936368', 'longitude': '-73.86454212450096', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:16.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:16.000 | 2019-03-02T12:18:43.000 | NaN |
| 58905 | 41316449 | 2019-01-01T11:32:20.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 11373.0 | 77-00 QUEENS BOULEVARD | QUEENS BOULEVARD | IRELAND STREET | ALBION AVENUE | NaN | NaN | ADDRESS | ELMHURST | NaN | Closed | 04 QUEENS | 4.024520e+09 | QUEENS | 1015767.0 | 208332.0 | PHONE | Unspecified | QUEENS | 40.738444 | -73.886270 | {'latitude': '40.73844369159779', 'longitude': '-73.88626983778089', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:17.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:17.000 | 2019-03-02T11:32:20.000 | NaN |
| 58906 | 41318974 | 2019-01-01T11:06:20.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Handwashing | Other (Explain Below) | 11217.0 | 576 ATLANTIC AVENUE | ATLANTIC AVENUE | 3 AVENUE | 4 AVENUE | 3 AVENUE | 4 AVENUE | ADDRESS | BROOKLYN | NaN | Closed | 02 BROOKLYN | 3.001860e+09 | BROOKLYN | 990116.0 | 188693.0 | PHONE | Unspecified | BROOKLYN | 40.684594 | -73.978849 | {'latitude': '40.684593521742336', 'longitude': '-73.97884944004804', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2024-06-03T10:07:59.000 | This SR was administratively closed. The issue you reported was addressed. | 2024-06-03T10:08:06.000 | 2019-02-07T11:06:20.000 | NaN |
| 58907 | 41317566 | 2019-01-01T10:50:27.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 11215.0 | 225 7 AVENUE | 7 AVENUE | 3 STREET | 4 STREET | NaN | NaN | ADDRESS | BROOKLYN | NaN | Closed | 06 BROOKLYN | 3.010800e+09 | BROOKLYN | 990092.0 | 183390.0 | ONLINE | Unspecified | BROOKLYN | 40.670038 | -73.978941 | {'latitude': '40.67003800101288', 'longitude': '-73.9789405717176', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:15.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:15.000 | 2019-03-02T10:50:27.000 | NaN |
| 58908 | 41316420 | 2019-01-01T10:40:40.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Rodents/Insects/Garbage | Restaurant/Bar/Deli/Bakery | 10014.0 | 75 GREENWICH AVENUE | GREENWICH AVENUE | 7 AVENUE | BANK STREET | NaN | NaN | ADDRESS | NEW YORK | NaN | Closed | 02 MANHATTAN | 1.006140e+09 | MANHATTAN | 983917.0 | 207684.0 | ONLINE | Unspecified | MANHATTAN | 40.736721 | -74.001202 | {'latitude': '40.73672124264221', 'longitude': '-74.0012016103804', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:17.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:17.000 | 2019-03-02T10:40:40.000 | NaN |
| 58909 | 41318119 | 2019-01-01T09:56:59.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Pet/Animal | Restaurant/Bar/Deli/Bakery | 11226.0 | 1603 CORTELYOU ROAD | CORTELYOU ROAD | EAST 16 STREET | EAST 17 STREET | NaN | NaN | ADDRESS | BROOKLYN | NaN | Closed | 14 BROOKLYN | 3.051470e+09 | BROOKLYN | 994404.0 | 173061.0 | ONLINE | Unspecified | BROOKLYN | 40.641683 | -73.963412 | {'latitude': '40.64168326471781', 'longitude': '-73.96341208990378', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:17.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:17.000 | 2019-03-02T09:56:59.000 | NaN |
| 58910 | 41314791 | 2019-01-01T08:38:30.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Toilet Facility | Restaurant/Bar/Deli/Bakery | 10022.0 | 1066 2 AVENUE | 2 AVENUE | EAST 56 STREET | EAST 57 STREET | NaN | NaN | ADDRESS | NEW YORK | NaN | Closed | 06 MANHATTAN | 1.013490e+09 | MANHATTAN | 993752.0 | 215704.0 | ONLINE | Unspecified | MANHATTAN | 40.758729 | -73.965701 | {'latitude': '40.758729026402136', 'longitude': '-73.96570127751059', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:17.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:17.000 | 2019-03-02T08:38:30.000 | NaN |
| 58911 | 41315010 | 2019-01-01T07:59:30.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Letter Grading | Restaurant/Bar/Deli/Bakery | 10466.0 | 4045 LACONIA AVENUE | LACONIA AVENUE | EAST 227 STREET | EAST 228 STREET | NaN | NaN | ADDRESS | BRONX | NaN | Closed | 12 BRONX | 2.048740e+09 | BRONX | 1026284.0 | 262179.0 | ONLINE | Unspecified | BRONX | 40.886195 | -73.847982 | {'latitude': '40.88619471722822', 'longitude': '-73.8479817460043', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-03T06:18:17.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-03T06:18:17.000 | 2019-03-02T07:59:30.000 | NaN |
| 58912 | 41307236 | 2019-01-01T01:17:04.000 | DOHMH | Department of Health and Mental Hygiene | Food Establishment | Kitchen/Food Prep Area | Restaurant/Bar/Deli/Bakery | 11212.0 | 9323 CHURCH AVENUE | CHURCH AVENUE | LINDEN BOULEVARD | EAST 94 STREET | NaN | NaN | ADDRESS | BROOKLYN | NaN | Closed | 17 BROOKLYN | 3.046900e+09 | BROOKLYN | 1007207.0 | 177753.0 | ONLINE | Unspecified | BROOKLYN | 40.654538 | -73.917263 | {'latitude': '40.654537851407625', 'longitude': '-73.91726308878049', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'} | 2019-03-02T06:18:22.000 | The Department of Health and Mental Hygiene has sent official written notification to the Owner/Landlord warning them of potential violations and instructing them to correct the situation. If the situation persists 21 days after your initial complaint, please make a new complaint. | 2019-03-02T06:18:22.000 | 2019-03-02T01:17:04.000 | NaN |